package com.fs.jzzn.repository;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;

import com.fs.jzzn.pojo.Materiel;

/**
 * @author ACE
 */
import java.lang.String;
public interface MaterielRepository extends JpaRepository<Materiel,String>, JpaSpecificationExecutor<Materiel>{
	
	@Query(value=" SELECT * FROM p_materiel WHERE  m_unit<> ''  GROUP BY m_unit  ",nativeQuery=true)
	List<Materiel> findAllUnit();
}
